﻿namespace Common.Constant
{
    public sealed class DBSchemas
    {
        //StoreProcedure Name
        private DBSchemas(){}

        public const string AddUser = "AddUser";
        public const string UpdateUser = "UpdateUser";
        public const string DeleteUser = "DeleteUser";
        public const string GetUserByUserName = "GetUserByUserName";
        public const string GetTopUser = "GetTopUser";
        public const string GetAllUsers = "GetAllUser";
        public const string CheckUser = "CheckUser";
        public const string CheckUserIsExists = "CheckUserIsExists";

        public const string AddPost = "AddPost";
        public const string UpdatePost = "UpdatePost";
        public const string DeletePost = "DeletePost";
        public const string GetPostByUser = "GetPostByUser";
        public const string GetPostByUserForManager = "GetPostByUserForManager";
        public const string GetPostByDate = "GetPostByDate";
        public const string GetTopPost = "GetTopPost";
        public const string GetTopViewPost = "GetTopViewPost";
        public const string GetTopCommentPost = "GetTopCommentPost";
        public const string GetNewPost = "GetNewPost";
        public const string GetAllPost = "GetAllPost";
        public const string GetPostByCategoryId = "GetPostByCategoryId";
        public const string GetPostById = "GetPostById";
        public const string UpdatePostView = "UpdatePostView";
        public const string UpdatePostComment = "UpdatePostComment";
        public const string PublishPost = "PublishPost";

        public const int NumberOfTopPost = 5;
        public const int NumberOfTopViewPost = 5;
        public const int NumberOfTopCommentPost = 5;
        public const string AdminRoleName = "admin";
        public const string UserRoleName = "user";
        public const bool DefaultCommentPublish = true;

        public const string AddCategory = "AddCategory";
        public const string UpdateCategory = "UpdateCategory";
        public const string DeleteCategory = "DeleteCategory";
        public const string GetCategoryById = "GetCategoryById";
        public const string GetAllCategory = "GetAllCategory";

        public const string AddComment = "AddComment";
        public const string UpdateComment = "UpdateComment";
        public const string DeleteComment = "DeleteComment";
        public const string GetCommentById = "GetCommentById";
        public const string GetCommentByPostId = "GetCommentByPostId";
        public const string GetAllComment = "GetAllComment";
        public const string GetCommentFromDate = "GetCommentFromDate";
        public const string AdminPublishComment = "AdminUnPublishComment";
    }
}
